# 项目：py-advance
# 文件：07-边框
# 作者：Frank Gong
# 日期：2025/2/21 11:28
# coding:utf-8
import openpyxl
from openpyxl.styles import Border,Side

wb = openpyxl.Workbook()
sheet = wb.active

border = Border(left=Side(style='dotted'),right=Side(style='medium'),
                top=Side(style='thin',color='FF0000'),bottom=Side(style='double'))

sheet['C3'].border = border

wb.save('../files/new4.xlsx')